SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweInstalaciones
AS
SELECT     idInstalacion AS ID, Descripcion, CantUtil, CantReparar, FrecuenciaRevision, UltInspeccion, Observaciones, TipoDeInstalacion, EstadoGeneral, 
                      CostoCapital, CostoAnualMantenim, VidaUtilPromedio
FROM         dbo.tb_Instalaciones
GO
GRANT SELECT ON  [dbo].[vweInstalaciones] TO [LegajoEdilico]
GRANT INSERT ON  [dbo].[vweInstalaciones] TO [LegajoEdilico]
GRANT UPDATE ON  [dbo].[vweInstalaciones] TO [LegajoEdilico]
GRANT SELECT ON  [dbo].[vweInstalaciones] TO [SoloVer]
GO
